package com.graduation.sfstore.dao;

import com.graduation.sfstore.entity.Consumeruser;
import com.graduation.sfstore.entity.OrderForm;
import com.graduation.sfstore.entity.SpeicesSort;
import com.graduation.sfstore.entity.Store;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface StoreMapper {

    List<Store> findAllStores(int regionid,int offset,int limit);

    List<SpeicesSort> findStoresSort(int offset,int limit);

    int findSpeciesSortRows();

    int selectStoreRows(int regionid);

    SpeicesSort findStores(String fishname);

    int insertfishstore(Store store);

    int insertfishstorein(Store store);

    int updatefishstore(int id,double weight,int type);

    int insertfishstoreout(Store store);

    int findMainAmountByName(String region);

    double findRegionWight(String region);

    double findRegionOutWight(String region);

    Consumeruser findConsumer(String name, String password);

    void insertOrder(OrderForm orderForm);

}
